if exists (select 1
   from dbo.sysreferences r join dbo.sysobjects o on (o.id = r.constid and o.type = 'F')
   where r.fkeyid = object_id('Admin_User_Roles') and o.name = 'FK_ADMIN_US_REFERENCE_ADMIN_US')
alter table Admin_User_Roles
   drop constraint FK_ADMIN_US_REFERENCE_ADMIN_US
go

if exists (select 1
            from  sysobjects
           where  id = object_id('Admin_User')
            and   type = 'U')
   drop table Admin_User
go

/*==============================================================*/
/* Table: Admin_User                                            */
/*==============================================================*/
create table Admin_User (
   UserId               char(36)             not null,
   Name                 varchar(255)         null,
   Password             varchar(255)         null,
   NickName             varchar(255)         null,
   TrueName             varchar(255)         null,
   MobilePhone          varchar(255)         null,
   EMailAddress         varchar(255)          null,
   IdNumber             varchar(255)         null,
   Address              varchar(255)         null,
   IsLock               char(1)              null,
   Age                  int                  null,
   Picture              Long RAW             null,
   Remark               varchar(255)         null,
   CreateId             char(36)             null,
   CreateDate           DATE                 null,
   UpdateId             char(36)             null,
   UpdateDate           DATE                 null,
   RowVerNo             timestamp            null,
   constraint PK_ADMIN_USER primary key (UserId)
)
go
